Taeluf.com

queries

a:10:{s:14:"article.create";s:298:"DROP TABLE IF EXISTS `article`;
CREATE TABLE IF NOT EXISTS `article` (
    `id` int(11) PRIMARY KEY,
    `title` varchar(256),
    `description` TEXT,
    `slug` varchar(256),
    `created_at` datetime, 
    `status` varchar(30),
    `related_article_id` int(11)
) ; 

DELETE FROM `article`;
-- END";s:19:"article.sample_data";s:408:"INSERT INTO `article` (`id`, `title`, `description`, `slug`, `created_at`, `status`, `related_article_id`)
    VALUES
    (1, 'One', 'Desc 1', 'one', CURRENT_TIMESTAMP, 'public', NULL),
    (2, 'Two', 'Desc 2', 'two', CURRENT_TIMESTAMP, 'public', NULL),
    (3, 'Three', 'Desc 3', 'three', CURRENT_TIMESTAMP, 'public', 1),
    (4, 'Four, Private', 'Desc 4', 'four-private', CURRENT_TIMESTAMP, 'private', 1)
;";s:18:"article.get_public";s:53:"SELECT * FROM `article` WHERE `status` LIKE 'public';";s:19:"article.get_private";s:54:"SELECT * FROM `article` WHERE `status` LIKE 'private';";s:17:"article.get_where";s:52:"SELECT * FROM `article` WHERE `status` LIKE :status;";s:26:"article.insert_with_status";s:193:"INSERT INTO `article` (`id`, `title`, `description`, `slug`, `created_at`, `status`, `related_article_id`)
    VALUES
    (5, 'Status', 'Status 1', 'status', CURRENT_TIMESTAMP, :status, NULL)
;";s:13:"author.create";s:260:"DROP TABLE IF EXISTS `author`;
CREATE TABLE IF NOT EXISTS `author` (
    `id` int(11) PRIMARY KEY,
    `name` varchar(256),
    `description` TEXT,
    `slug` varchar(256),
    `created_at` datetime, 
    `status` varchar(30)
) ; 

DELETE FROM `author`;
-- END";s:18:"author.sample_data";s:385:"INSERT INTO `author` (`id`, `title`, `description`, `slug`, `created_at`, `status`)
    VALUES
    (1, 'One', 'Desc 1', 'one', CURRENT_TIMESTAMP, 'public', NULL),
    (2, 'Two', 'Desc 2', 'two', CURRENT_TIMESTAMP, 'public', NULL),
    (3, 'Three', 'Desc 3', 'three', CURRENT_TIMESTAMP, 'public', 1),
    (4, 'Four, Private', 'Desc 4', 'four-private', CURRENT_TIMESTAMP, 'private', 1)
;";s:10:"tag.create";s:251:"DROP TABLE IF EXISTS `tag`;
CREATE TABLE IF NOT EXISTS `tag` (
    `id` int(11) PRIMARY KEY,
    `name` varchar(256),
    `description` TEXT,
    `slug` varchar(256),
    `created_at` datetime, 
    `status` varchar(30)
) ; 

DELETE FROM `tag`;
-- END";s:15:"tag.sample_data";s:382:"INSERT INTO `tag` (`id`, `title`, `description`, `slug`, `created_at`, `status`)
    VALUES
    (1, 'One', 'Desc 1', 'one', CURRENT_TIMESTAMP, 'public', NULL),
    (2, 'Two', 'Desc 2', 'two', CURRENT_TIMESTAMP, 'public', NULL),
    (3, 'Three', 'Desc 3', 'three', CURRENT_TIMESTAMP, 'public', 1),
    (4, 'Four, Private', 'Desc 4', 'four-private', CURRENT_TIMESTAMP, 'private', 1)
;";}